Values for IANAAppCodePage Connection String Attribute
Table F-1 lists supported values, along with a description, for the IANAAppCodePage connection string attribute at the time of this publication. Support for additional values may have been added since publication time; therefore, for up-to-date values, go to:
http://www.datadirect.com/support/troubleshooting/su-faq-iana/index.ssp
See "Connecting Using a Connection String" for more information about this connection string attribute.
To determine the correct numeric value (the MIBenum value) for the IANAAppCodePage connection string attribute, do the following:
- Determine the code page of your database.
- Determine the MIBenum value that corresponds to your database code page. To do this, go to:
http://www.iana.org/assignments/character-sets
On this Web page, search for the name of your database code page. This name will be listed as an alias or the name of a character set and will have a MIBenum value associated with it.
- Check the table in this appendix to make sure that the MIBenum value you looked up on the IANA Web page is supported by SequeLink Client for ODBC. If the value is not listed, contact DataDirect Technologies technical support to request that support for that value be added.
Table F-1. IANAAppCodePage Values
|
IANAAppCodePage
|
IANA Character Set Name
|
|
3
|
US_ASCII
|
|
4
|
ISO_8859_1
|
|
5
|
ISO_8859_2
|
|
6
|
ISO_8859_3
|
|
8
|
ISO_8859_5
|
|
9
|
ISO_8859_6
|
|
10
|
ISO_8859_7
|
|
11
|
ISO_8859_8
|
|
12
|
ISO_8859_9
|
|
17
|
Shift_JIS
|
|
18
|
EUC_JP
|
|
38
|
EUC_KR
|
|
106
|
UTF-8
|
|
109
|
ISO_8859_13
|
|
111
|
ISO_8859_15
|
|
113
|
GBK
|
|
114
|
GB18030
|
|
2004
|
HP_ROMAN8
|
|
2009
|
IBM850
|
|
2025
|
2025 GB2312
|
|
2026
|
Big5
|
|
2084
|
KOI8_R
|
|
2088
|
KOI8-U
|
|
2251
|
WINDOWS_1251
|
|
2252
|
WINDOWS_1252
|
|
2259
|
TIS_620
|
|
10001
|
IBM-856
|
|
10003
|
IBM-921
|
|
10004
|
IBM-922
|
|
10012
|
IBM-943
|
|
10024
|
IBM-1046
|
|
10030
|
IBM-1124
|
Solaris
Table F-2 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 6.0 or higher for ODBC on the Solaris platform.
Table F-2. Code Pages Supported on Solaris
|
Code page
|
IANA Character Set Name
|
IANAAppCodePage
|
|
646
|
US_ASCII
|
3
|
|
ISO8859-1
|
ISO_8859_1
|
4
|
|
ISO8859-2
|
ISO_8859_2
|
5
|
|
ISO8859-5
|
ISO_8859_5
|
8
|
|
ISO8859-6
|
ISO_8859_6
|
9
|
|
ISO8859-7
|
ISO_8859_7
|
10
|
|
ISO8859-8
|
ISO_8859_8
|
11
|
|
ISO8859-9
|
ISO_8859_9
|
12
|
|
PCK
|
Shift_JIS
|
17
|
|
eucJP
|
EUC_JP
|
18
|
|
ISO8859-13
|
ISO_8859_13
|
109
|
|
ISO8859-15
|
ISO_8859_15
|
111
|
|
GBK
|
GBK
|
113
|
|
UTF-8
|
UTF-8
|
106
|
|
gb2312
|
GB2312
|
2025
|
|
BIG5
|
Big5
|
2026
|
|
KOI8-R
|
KOI8_R
|
2084
|
|
TIS620.2533
|
TIS_620
|
2259
|
HP
Table F-3 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 6.0 or higher for ODBC on the HP-UX platform.
Table F-3. Code Pages Supported on HP-UX
|
Code page
|
IANA Character Set Name
|
IANAAppCodePage
|
|
iso88591
|
ISO_8859_1
|
4
|
|
iso88592
|
ISO_8859_2
|
5
|
|
iso88595
|
ISO_8859_5
|
8
|
|
iso88596
|
ISO_8859_6
|
9
|
|
iso88597
|
ISO_8859_7
|
10
|
|
iso88598
|
ISO_8859_8
|
11
|
|
iso88599
|
ISO_8859_9
|
12
|
|
utf8
|
UTF-8
|
106
|
|
big5
|
Big5
|
2026
|
|
tis620
|
TIS_620
|
2259
|
|
roman8
|
HP_ROMAN8
|
2004
|
AIX
Table F-4 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 6.0 or higher for ODBC on the AIX platform.
Table F-4. Code Pages Supported on AIX
|
Code Page
|
IANA Character Set Name
|
IANAAppCodePage
|
|
kIANACS_MIB_US_ ASCII
|
US_ASCII
|
3
|
|
ISO8859-1
|
ISO_8859_1
|
4
|
|
ISO8859-2
|
ISO_8859_2
|
5
|
|
ISO8859-5
|
ISO_8859_5
|
8
|
|
ISO8859-6
|
ISO_8859_6
|
9
|
|
ISO8859-7
|
ISO_8859_7
|
10
|
|
ISO8859-8
|
ISO_8859_8
|
11
|
|
ISO8859-9
|
ISO_8859_9
|
12
|
|
IBM-eucJP
|
EUC_JP
|
18
|
|
IBM-eucKR
|
EUC_KR
|
38
|
|
ISO8859-15
|
ISO_8859_15
|
111
|
|
GBK
|
GBK
|
113
|
|
UTF-8
|
UTF-8
|
106
|
|
IBM-850
|
IBM-850
|
2009
|
|
big5
|
Big5
|
2026
|
|
IBM-1252
|
WINDOWS_1252
|
2252
|
|
TIS-620
|
TIS_620
|
2259
|
|
IBM-856
|
IBM-856
|
10001
|
|
IBM-921
|
IBM-921
|
10003
|
|
IBM-922
|
IBM-922
|
10004
|
|
IBM-943
|
IBM-943
|
10012
|
|
IBM-1046
|
IBM-1046
|
10024
|
|
IBM-1124
|
IBM-1124
|
10030
|
Linux
Table F-5 lists supported code pages, IANA character set name and IANAAppCodePage for the SequeLink Client 6.0 or higher for ODBC on the Linux platform.
Table F-5. Code Pages Supported on Linux
|
Code Page
|
IANA Character Set Name
|
IANAAppCodePage
|
|
ANSI_X3.4-1968
|
US_ASCII
|
3
|
|
ISO-8859-1
|
ISO_8859_1
|
4
|
|
ISO-8859-2
|
ISO_8859_2
|
5
|
|
ISO-8859-3
|
ISO_8859_3
|
6
|
|
ISO-8859-5
|
ISO_8859_5
|
8
|
|
ISO-8859-5
|
ISO_8859_6
|
9
|
|
ISO-8859-7
|
ISO_8859_7
|
10
|
|
ISO-8859-8
|
ISO_8859_8
|
11
|
|
ISO-8859-9
|
ISO_8859_9
|
12
|
|
EUC-JP
|
EUC_JP
|
18
|
|
EUC-KR
|
EUC_KR
|
38
|
|
ISO-8859-13
|
ISO_8859_13
|
109
|
|
ISO-8859-15
|
ISO_8859_15
|
111
|
|
GBK
|
GBK
|
113
|
|
GB18030
|
GB18030
|
114
|
|
UTF-8
|
UTF-8
|
106
|
|
GB2312
|
2025 GB2312
|
2025
|
|
BIG5
|
Big5
|
2026
|
|
KOI8-R
|
KOI8_R
|
2084
|
|
KOI8-U
|
KOI8-U
|
2088
|
|
CP1251
|
WINDOWS_1251
|
2251
|
|
TIS-620
|
TIS_620
|
2259
|
Windows
Table F-6 lists supported code pages, code page name, MIB number, and IANA character set name for the SequeLink Client 6.0 or higher for ODBC on the Windows platform.
Table F-6. Code Pages Supported on Windows
|
Codepage
|
Codepage Name
|
MIBenum
|
IANA Character Set Name
|
|
932
|
Japanese Shift-JIS
|
17
|
Shift_JIS
|
|
936
|
Simplified Chinese GBK
|
113
|
GBK
|
|
949
|
Korean
|
10015
|
WINDOWS_949
|
|
950
|
Simplified Chinese Big5
|
2026
|
Big5
|
|
1250
|
Central Europe
|
2250
|
WINDOWS_1251
|
|
1251
|
Cyrillic
|
2251
|
WINDOWS_1251
|
|
1252
|
Latin I
|
2252
|
WINDOWS_1252
|
|
1253
|
Greek
|
2253
|
WINDOWS_1253
|
|
1254
|
Turkish
|
2254
|
WINDOWS_1254
|
|
1255
|
Hebrew
|
2255
|
WINDOWS_1255
|
|
1256
|
Arabic
|
2256
|
WINDOWS_1256
|
|
1257
|
Baltic
|
2257
|
WINDOWS_1257
|
|
1258
|
Vietnam
|
2258
|
WINDOWS_1258
|